SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001341s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 198040 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 198040 [ RunTime:0.001560s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (577098,785508,790020,437231,844239,916890,8305,473135,1027149,228838,851131,231588,970633,665039,154165,273588,365548,359463,174552,782803,167791,960842,207017,402660,855325,938717,736682,998692,446468,938081,861586,772319,867200,856086,352292,897500,835749,1033430,506912,1019381,954929,405113,961726,98108,957909,249339,150831,594410,394111,552797,352276,461387,133845,547589,272700,750544,635875,222516,24039,589180) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 198040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 198040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000472s ]