SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 145208 LIMIT 1 [ RunTime:0.000290s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 145208 [ RunTime:0.001433s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (245093,506762,755009,683483,436704,599828,921187,69588,1020907,853522,619375,624494,881325,606155,345205,230966,381544,945823,338353,344356,207752,460093,817993,676715,185773,633759,425304,732628,922167,404393,21434,241359,709069,987903,949900,1946,147611,1036461,113849,252149,890928,337496,374273,334632,702262,827710,415804,472320,4898,148714,726608,778285,465546,402550,164004,275010,585536,293959,392498,9472) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 145208 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 145208 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001845s ]