SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 284083 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 284083 [ RunTime:0.001690s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (91369,514774,210499,249021,429504,575819,847706,588575,580615,1015277,287691,283321,172521,543874,471772,501658,394666,780636,212716,346582,626400,118389,264936,428146,720929,149330,956115,84092,617622,551345,545982,596989,944741,674586,908187,356963,620635,552979,1006181,681539,478859,823086,935913,66685,510940,4893,156719,385707,973891,881244,232221,427458,843756,514746,154959,205208,333439,419266,1020777,267989) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000969s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 284083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 284083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]