SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 440543 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 440543 [ RunTime:0.003128s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (305639,808938,448453,170680,506396,120257,894341,527884,510016,284496,157727,30127,823318,37286,792752,806944,54818,285195,19494,1016135,813893,681904,937462,956995,196897,27171,922932,666353,155778,268296,660844,111639,896292,850531,60583,1016453,370005,745531,984247,516307,805511,324062,881645,44755,741687,416893,505606,468223,36438,401761,994457,1028656,910252,851049,796699,576000,623493,601556,618050,186476) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 440543 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000517s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 440543 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000669s ]