SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 443509 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 443509 [ RunTime:0.002700s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (705949,368606,718757,204038,706603,756447,482674,466503,208657,207527,496363,653591,421716,382798,715129,69477,647127,819117,608210,694486,868441,423652,99728,810591,1029384,499475,923371,247066,659779,920119,371561,48481,330730,691375,284086,337966,902071,438016,156141,446186,1007123,659314,1031299,562758,425512,319915,99869,441471,761320,593270,421423,676799,129909,562855,905894,601632,452694,776367,727642,503487) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 443509 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 443509 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001344s ]