SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1044460 LIMIT 1 [ RunTime:0.000477s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044460 [ RunTime:0.001781s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (167368,989317,955766,183238,586467,670637,183861,78271,582907,557110,541373,107963,713911,109588,842203,102640,919288,698327,548841,179950,68896,586632,87789,637939,684748,265739,951605,248850,976822,914316,1034052,869841,659999,189406,695171,699607,542465,1015,382096,372975,253102,541303,83826,631045,46121,428587,439764,994178,395319,554393,61215,88728,932565,472384,699577,677825,734292,10355,310549,599429) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001688s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1044460 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000558s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1044460 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000700s ]