SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002442s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 474726 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 474726 [ RunTime:0.001544s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (522364,818696,176436,1012738,483726,508049,867220,331407,586039,310929,381178,550768,409584,435183,957627,328537,250016,728697,766487,453783,305825,836642,43309,406224,475189,487701,805809,131133,535076,870177,1002337,580868,165853,100929,1013105,381719,115514,863646,635291,697957,712147,268054,24514,623180,942520,894386,987823,382798,590912,999822,533576,206750,364128,697769,526154,469237,345704,972103,132122,300915) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 474726 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 474726 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]