SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 334307 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 334307 [ RunTime:0.001790s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1011715,991786,22897,338181,779524,762744,943671,917366,975180,674475,41256,577254,876882,1030215,501997,691249,161437,534033,1003910,971264,801839,427819,215819,517320,781341,347684,975054,447033,4393,960083,836644,391255,807863,471171,787466,1039974,83619,583905,513842,183562,1014495,121075,785238,428084,601037,756107,343590,505714,422022,811619,621213,247861,580902,688395,1020843,246190,860788,602378,458004,93933) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 334307 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 334307 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]