SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 484322 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 484322 [ RunTime:0.002360s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (358096,206796,99340,764405,1016251,412240,927094,338713,675860,991220,908386,125180,625346,621970,728513,763917,150196,844219,852875,2444,755070,1014862,570482,934484,270732,48248,1033473,314880,320888,648052,705997,328765,326960,408903,952675,5690,538698,512,317424,81680,827171,408238,518561,710539,133430,581045,101387,78685,545672,46051,725394,118940,206286,882685,639994,204529,202240,16762,563848,221832) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 484322 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 484322 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]