SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1033847 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1033847 [ RunTime:0.001515s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1003368,113414,466847,589488,571230,755784,557492,375541,732835,914734,173178,553819,720262,628927,152702,565787,648503,705963,590179,592490,698363,298806,593589,841353,1027117,374485,904016,200728,968965,960986,689366,464336,527062,273858,701496,943733,81570,1009828,462556,890625,999745,1003513,424573,755766,81942,293476,898494,686604,935160,629304,444296,895534,777735,751225,1010175,51805,118647,908527,760968,621931) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1033847 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000521s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1033847 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000782s ]