SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 184083 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 184083 [ RunTime:0.002399s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (67654,608608,577314,670195,307754,191495,552786,868444,88362,812287,884423,185378,677333,439640,757947,38544,729103,94441,341328,737718,677256,178247,205472,699667,991198,171259,504590,264027,948004,108288,275407,210257,536006,96500,321736,820888,859635,710397,158444,142428,542553,119187,1002000,601522,588394,445442,373124,131292,534421,154757,390193,374280,383660,377443,991600,84135,492224,297282,157177,696784) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 184083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000610s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 184083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000438s ]