SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001962s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501818 LIMIT 1 [ RunTime:0.000756s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501818 [ RunTime:0.002025s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (35029,526412,577974,789580,898578,49044,671007,594211,225998,340054,929386,1000297,388007,972766,215993,392845,92698,25352,144310,541635,244105,590507,29402,183742,246311,531251,710137,110853,347458,57778,691556,258113,167409,556541,378841,209051,259429,87112,764053,8959,848270,333431,599859,953787,1011231,991919,1000138,28609,62013,708104,761605,74599,77607,350984,947342,438064,725686,931064,168735,4088) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501818 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501818 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000790s ]