SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003728 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003728 [ RunTime:0.001550s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (284464,994338,617997,526577,342807,296763,156285,957921,987375,387932,803213,827508,439028,493646,708504,535142,495154,1038283,398527,720653,25629,239411,107472,764463,877377,1030573,314459,497168,639199,57737,689841,46966,701113,656196,399857,3558,980169,927761,379961,223588,514753,674688,769197,509762,749876,28011,96902,232247,747774,966777,934916,49162,44128,48123,644604,90174,1011415,324093,506087,901717) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001784s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003728 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003728 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000387s ]