SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001808s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 266019 LIMIT 1 [ RunTime:0.001065s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 266019 [ RunTime:0.003016s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (258678,315033,73830,688036,852610,360741,453490,938443,510030,749592,378248,182023,515120,397741,716916,782982,189182,994052,114266,590271,80849,612363,558135,584678,639973,449765,1018191,119490,179936,388965,186274,81300,466293,72298,32197,44585,505653,235124,856357,924245,851902,327176,399268,232768,199214,77487,521294,444756,98347,470830,96231,592146,422614,225702,218879,128417,954436,425291,274827,921334) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001709s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 266019 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 266019 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]