SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1048043 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1048043 [ RunTime:0.001797s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (310378,1022363,321696,265279,787488,398274,1023497,500425,899575,594318,146574,936079,927561,895404,906369,188823,107035,805436,182365,648905,336018,1023564,613676,443962,327589,996537,639394,402939,880389,993409,572564,992524,835184,704936,981323,763866,427756,289364,506572,8703,531456,567089,205430,539791,94146,367566,733660,857976,605713,496451,733288,442511,292420,813986,1019007,367998,903965,8538,954847,310231) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1048043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1048043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000648s ]