SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001816s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 686216 LIMIT 1 [ RunTime:0.002825s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 686216 [ RunTime:0.003416s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (407546,1012607,749278,340276,704315,441073,564853,807833,81268,979710,403110,810709,818054,443675,123119,795464,640630,973228,831998,59281,829865,149562,275804,475029,70549,870405,694689,307594,455499,219701,672070,706839,208726,130728,721600,451322,930504,918623,439551,140651,428466,190880,953266,726183,973592,604070,913541,308220,918699,162696,840029,155206,199714,35496,137567,478461,517061,341662,645621,807465) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 686216 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 686216 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000456s ]