SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001438s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104202 LIMIT 1 [ RunTime:0.001028s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104202 [ RunTime:0.001916s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (254026,486861,624743,62178,353168,573240,1005773,767952,264066,641104,671701,751047,971350,566999,95107,967575,216780,849541,270667,901677,938410,686629,671618,854132,361473,521517,925061,4163,854014,820060,669692,333455,853666,196525,562656,344085,311196,683335,828492,333484,474911,295394,889670,532397,844631,818199,746108,895512,553943,1003920,448318,565354,345890,782580,1813,230834,676483,362923,752104,955169) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104202 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104202 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000697s ]