SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001617s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5318 LIMIT 1 [ RunTime:0.000449s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5318 [ RunTime:0.003544s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1030589,176887,42373,412365,677299,431773,55157,98268,104656,65296,87667,587301,635717,822978,623379,357639,770142,76220,145245,531220,537932,782535,6582,811598,411275,478864,994596,510718,93543,474665,616034,1017579,146183,483093,298882,319537,336547,499256,686335,348170,250770,592380,545945,56974,96170,901698,881543,745924,509876,725616,169149,736728,681884,239119,152557,217199,1026876,525866,23687,404799) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5318 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000585s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5318 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001499s ]