SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34780 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34780 [ RunTime:0.002456s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (929100,964962,372948,35923,696647,670913,535947,175250,458467,102962,1017404,731278,418654,298879,466444,175319,38811,839003,147684,851249,6899,812180,645121,261649,529080,809603,28781,825855,487113,687096,517754,164909,631561,621421,257725,913278,465413,150693,1006124,950489,829186,195853,1022976,697447,326767,281309,753593,288449,809142,514632,1000104,382881,505612,987035,889976,511094,163370,42404,588824,520881) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34780 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34780 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]