SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404798 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404798 [ RunTime:0.002930s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (224219,538184,389174,364066,374755,632365,501157,925087,269373,633652,633871,608303,170350,737202,676603,998105,212148,1013171,1036116,434672,790280,126254,25060,320361,622657,150941,114020,527113,460787,947906,198417,160444,737611,209948,810307,22555,713813,686558,677883,316014,2746,871860,736737,482167,762867,448868,847421,1045380,227747,576381,191593,943,992974,702534,548874,95059,698177,454882,383111,993221) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404798 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404798 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000420s ]