SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420842 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420842 [ RunTime:0.001542s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (827787,533796,538413,480355,1023975,249974,978307,292729,632809,229773,617978,265521,391544,577493,695466,31196,122550,338878,856378,631919,984801,512983,472888,288005,995643,223548,198130,70595,331214,289728,695098,354462,173822,1030150,980399,912144,429168,266774,283868,380099,210174,39593,958130,311191,549239,160759,519544,117774,892698,321874,1015330,258850,208370,375933,751887,431848,246176,678457,920580,773416) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420842 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420842 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002199s ]