SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001589s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 677223 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 677223 [ RunTime:0.001899s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (496764,121616,1010570,639012,192779,985146,753233,661923,879680,626284,112063,887346,588854,129934,99655,598190,782765,76656,211897,13858,327585,1006472,25298,588156,135584,1013216,218285,785147,1047127,46660,405735,932518,971041,707589,285692,401720,259435,450836,503701,632034,678030,535405,80450,562589,913215,833030,424441,181427,207948,25013,373922,718101,377866,117205,713754,407184,637263,198339,245772,743850) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 677223 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 677223 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000396s ]