SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 597306 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 597306 [ RunTime:0.003066s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (123956,1006723,1035810,371519,336670,619189,901394,165417,322815,898796,275673,390948,904107,485432,497008,373653,74860,833219,307119,148761,668582,549679,234340,1035571,666121,854434,33785,947414,572848,434660,410235,781583,423872,553211,764229,265614,209165,733053,141205,137591,436748,533011,655195,879513,998240,304087,892725,976924,418732,278160,601391,78622,504416,70472,13845,599787,288597,605847,801981,676569) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000955s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 597306 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 597306 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000400s ]