SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003369s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 687241 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 687241 [ RunTime:0.005117s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (575103,113437,383365,67708,768755,100666,162254,896988,944940,484884,501725,15283,653183,259822,942667,504635,185277,306791,778266,363567,356960,769259,933004,244595,541813,887293,973688,459928,172412,1035881,996517,458556,852768,536704,542605,166384,910398,648700,170565,698833,306839,211735,777495,740652,696179,605287,815503,983633,671098,802502,948753,373045,612783,300325,423493,963289,6883,472634,686432,942276) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 687241 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 687241 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000858s ]