SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 493164 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 493164 [ RunTime:0.001602s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (621760,993685,175402,396554,211929,142522,287796,864513,318242,111299,805457,723992,497637,261913,785568,550003,938878,631155,406579,374580,329422,973687,90592,608869,458883,992138,675411,677887,803158,424828,104149,913314,174215,997302,169416,397006,172997,121478,546460,113960,768838,967293,63421,807924,450290,129691,816134,167220,632290,30428,673105,82866,436269,128542,362510,245766,832511,96263,296815,192017) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 493164 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 493164 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]