SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520697 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520697 [ RunTime:0.001650s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (58429,289966,355371,638504,17692,716135,349836,836061,140408,610487,636020,237972,30366,908654,343028,345618,742531,661546,727394,259456,441947,671267,827741,366345,418073,126915,934555,688605,785916,104460,640632,580112,191925,364073,769027,969164,301318,639088,819098,245247,631572,406593,887298,1001455,587480,376569,532583,659997,487570,585305,270272,642205,476126,19073,273223,902710,897265,34878,876393,769942) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520697 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520697 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]