SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040161 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040161 [ RunTime:0.001659s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (517252,513112,403951,383671,919485,652209,867508,6905,395033,243025,811408,462116,390325,721088,649907,48941,563784,742378,230181,677231,1035171,986402,666478,726401,759451,1037614,903948,481944,430777,697204,307282,473224,391989,918071,612758,763846,1006370,356967,590588,31383,723267,259981,178137,816557,684635,7912,1001937,432221,693973,939193,905406,92623,341723,83918,72081,147883,379393,886365,374821,663563) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040161 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040161 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]