SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 348938 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 348938 [ RunTime:0.004771s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (605535,62974,136604,174942,300268,229142,569027,104478,936190,241310,352251,876563,505869,392134,92402,128061,813889,714869,100509,811963,873347,253798,419549,783888,254042,818765,963904,622661,905968,842880,568847,493918,634987,1016812,609698,143418,159466,719743,364479,526020,14609,728525,37860,56240,685489,636561,363208,746145,262218,517048,242754,472537,1030713,6658,286993,112585,952257,207019,130743,716980) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 348938 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000526s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 348938 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]