SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423898 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423898 [ RunTime:0.001683s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (472632,188762,669484,430062,145643,552476,445100,1042257,474533,787987,887468,1036294,55824,211542,541576,561795,314223,607757,295489,751382,1455,661117,981695,664259,703041,776409,802236,628354,43696,1039816,27473,822150,669731,1029006,976645,499113,943470,1033508,426762,761446,102890,373527,766914,505227,305694,108973,435277,316841,383187,481922,184304,398912,322997,842040,929849,485056,529756,620423,59874,45249) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000938s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423898 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423898 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]