SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001459s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 279941 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 279941 [ RunTime:0.002036s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (577149,30472,242406,466382,311495,236728,81806,253722,521142,938932,712019,421417,28198,640868,820719,962283,19475,137078,918951,523583,126016,147297,564862,406718,882005,871527,836641,845058,977695,213802,261063,822961,448003,807802,505711,587042,642907,601779,770477,483843,754956,401131,922608,310494,473892,827730,859673,518908,93597,1018734,603592,146353,442615,168135,91098,147048,476504,5506,133130,826218) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001676s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 279941 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 279941 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000836s ]