SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023082 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023082 [ RunTime:0.002760s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (342726,191005,402383,48827,723471,504490,238744,76509,44645,802381,539008,337546,605095,783157,790281,329238,81817,730956,932759,618575,396268,449769,567694,152130,406003,886643,111165,263952,174010,932135,1004169,432902,994933,774737,365602,581459,894777,485140,223687,950884,413294,599121,929490,135269,973905,308559,681116,819200,517364,78588,386810,45919,993156,673250,665746,679506,326315,835500,726806,862615) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003201s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023082 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023082 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000680s ]