SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201260 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201260 [ RunTime:0.002190s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (881737,416424,664326,668768,361909,356111,853848,59799,619837,374790,637896,745777,549666,866002,383705,7931,347320,692279,1015298,110897,799772,497910,693478,627468,731866,381331,370437,193182,616723,498284,224624,796028,672879,748571,1010201,785075,473338,419540,447673,928420,61751,280987,510763,372655,831136,198793,324036,872551,410253,437507,540201,523,905797,228192,209329,304801,531718,1010594,137547,222467) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201260 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201260 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]