SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419009 LIMIT 1 [ RunTime:0.001225s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419009 [ RunTime:0.002011s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1036759,491877,694633,260996,597101,489137,245362,573995,612401,83215,608898,432778,437942,164432,992958,933129,764107,270072,36361,581798,520914,193232,720368,405629,161249,668787,1025360,40757,832567,614162,860117,685948,427643,426419,883553,585577,191045,126872,298120,947924,422327,238541,550139,313562,378967,309781,980816,163348,442606,159518,746831,634767,140045,68458,549353,646666,72020,770764,574837,719867) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419009 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419009 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000666s ]