SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001465s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106906 LIMIT 1 [ RunTime:0.002458s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106906 [ RunTime:0.007615s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (228634,1030702,143604,863378,105736,558633,289961,482573,705860,442980,491729,367871,530304,640820,985250,184348,733785,913155,740732,381371,964609,1048529,348591,264102,237599,839609,222811,851837,959149,174026,790270,365217,312301,652501,818862,172485,995632,254556,1028732,839714,426699,247892,860741,1033658,429960,341631,790501,672326,191097,823646,389782,353761,897446,716574,29244,870142,216953,5585,135952,813574) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.012087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106906 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106906 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]