SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540525 LIMIT 1 [ RunTime:0.000280s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540525 [ RunTime:0.001830s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (748678,500287,811247,228978,1027285,647251,566034,47938,1023343,599414,687702,144276,218804,21262,528565,853878,600226,631331,920311,599659,832080,936078,1043514,740859,885806,354160,311858,510785,879768,654896,85686,852411,1012430,1035976,354845,99052,472759,31684,848505,8041,26735,363888,178841,851973,233962,1041852,564045,532599,226022,737183,196376,708370,702361,550633,464169,568014,746997,627236,346824,122566) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540525 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540525 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]