SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001329s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 302681 LIMIT 1 [ RunTime:0.000444s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 302681 [ RunTime:0.002967s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (501591,8993,874446,268387,372069,246944,79143,863420,543804,385019,199350,970281,298140,941747,1000208,948617,175000,1046844,161289,747796,53170,921394,511777,758733,800550,639351,719267,637900,1036635,332836,273880,998188,861037,758069,558763,858354,1036326,786739,691303,450572,228402,1025434,980584,990001,418090,113266,475871,251930,17970,179171,695782,286243,593727,228660,744819,496724,309684,725791,901468,279607) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 302681 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 302681 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000769s ]