SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802399 LIMIT 1 [ RunTime:0.000286s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802399 [ RunTime:0.002345s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (644610,349967,890058,376859,831087,273310,589645,226770,159597,686291,561164,862862,1009731,684077,165030,700034,450824,864139,894378,50408,396503,988354,902276,756601,303006,863866,105285,603414,498577,318424,110608,905608,27780,602345,330579,886140,840010,906771,741650,57348,95041,777050,904644,603944,751337,51847,252150,1030174,691223,608993,1037933,42349,500643,1004271,107008,184080,699515,213604,408085,213252) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802399 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802399 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]