SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 513935 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 513935 [ RunTime:0.003038s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (137388,712943,512557,981767,128932,896779,4393,111008,944148,844099,401864,18140,1007909,408939,622280,881642,988342,649558,309944,976172,676710,586247,495225,735446,398883,966544,1031045,867794,105505,269330,778837,280807,724680,536757,158844,182190,283027,484512,56965,630335,423195,505398,895908,404383,164804,861782,471008,559094,750474,144127,539740,591130,860564,678241,936445,1034376,255420,1045118,170735,904563) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 513935 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000543s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 513935 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002278s ]