SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003822s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5051 LIMIT 1 [ RunTime:0.000452s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5051 [ RunTime:0.001637s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (411653,640880,751388,188309,386261,852152,728390,851798,328607,938352,1036326,573571,535396,650423,474234,867139,176347,1023713,908169,779226,639995,462104,750299,267671,1037400,341599,453341,550707,951163,449887,735230,157391,1000156,586587,206814,390960,279231,870925,772032,443835,514518,926701,962683,783228,702916,193277,497456,891909,304603,235970,226255,284508,372925,827569,724909,665421,497100,126585,861124,94909) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5051 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5051 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000655s ]