SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1013854 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1013854 [ RunTime:0.002048s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (127931,487858,471790,519215,571106,1022890,848356,739265,984678,1046865,633407,693443,158457,508752,700245,895515,640985,498806,844133,718929,464683,243462,633782,627253,413865,623228,409461,278148,940929,385724,51658,926277,557101,915542,678337,879551,49912,999315,940713,808237,199864,515377,547842,657715,836865,974097,400246,545529,949534,107696,726809,936581,978294,665340,420952,25388,850971,821330,249737,27855) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1013854 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1013854 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]