SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540081 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540081 [ RunTime:0.002340s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (947701,760864,925947,18439,32951,711059,820646,843509,906054,185188,598121,779757,728255,685773,225922,782365,209010,136095,145427,375306,629913,642510,821869,590059,430184,716712,150449,507796,970945,246204,661814,609151,316238,94468,373140,471365,621980,926375,228576,478561,43296,657319,894699,630616,428456,146436,729892,20892,639356,498147,147518,585814,251994,731356,250844,546149,734669,288405,913993,293666) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540081 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000504s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540081 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]