SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 163510 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 163510 [ RunTime:0.001583s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (786579,103705,1048840,998457,971137,541008,271333,603731,338039,969224,146148,858842,73324,270123,960037,975708,483650,160473,206873,242554,834511,367156,522892,792434,821646,353574,923851,449662,125613,734068,358201,1043425,478079,147515,578278,787949,323172,860689,605533,1023071,660644,297195,700071,225762,341857,553409,705797,562043,300680,429873,176139,603131,920517,639864,636922,608467,872168,92558,62604,302135) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001657s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 163510 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 163510 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]