SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001713s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 2809 LIMIT 1 [ RunTime:0.000670s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 2809 [ RunTime:0.002650s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (501383,214802,426987,209111,620134,540978,678210,862347,462602,915010,386240,920885,145304,838155,19947,924193,530990,859182,111501,288904,688164,760333,679742,895891,1028445,708879,690303,607618,828140,812053,515657,52935,272598,812776,526273,973411,456613,147678,275886,577610,548181,276630,508488,280315,96097,723321,250556,536030,669157,215777,920166,668234,224064,1047181,115204,71351,620078,836426,503645,275793) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002646s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 2809 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000614s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 2809 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002184s ]