SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022260 LIMIT 1 [ RunTime:0.000464s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022260 [ RunTime:0.002121s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (777722,986965,304604,875787,58252,312111,430320,596316,915329,295404,996058,632123,100657,74453,117010,874741,135376,744482,1018992,198232,336563,166287,41950,1024571,580745,790310,238224,927539,735185,284959,49655,798690,24368,501805,164740,151210,825059,242682,824896,409638,333627,115191,42718,906833,446933,56381,490417,1000359,518320,172203,1111,866385,460037,1033146,25025,169130,892856,575234,1022364,1040989) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022260 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022260 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]