SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010382 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010382 [ RunTime:0.004919s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (687344,424877,691367,863211,683827,349455,56564,839267,962144,100196,563478,1026833,215299,577817,678786,729593,12805,116748,416143,62227,428613,987194,5447,599509,201398,671297,344682,831861,570507,586756,150510,379842,922131,368546,472118,276086,289912,335076,177037,507898,112382,460375,1025247,422126,41817,754428,59732,966693,59320,895049,367479,898523,145442,476179,385970,446886,178621,434787,685596,575249) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010382 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010382 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]