SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101497 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101497 [ RunTime:0.002120s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (253116,204040,431265,261982,186687,738874,433049,403140,689384,356973,708897,141063,483013,275604,41450,381669,635713,564866,369349,363842,724707,448362,5114,700537,1017862,969252,824967,103314,54753,40836,456624,660132,397232,312164,749306,4433,859528,790125,720101,428585,927127,3935,207789,910720,699932,986552,178786,264943,303084,978500,331154,601285,438768,607636,367575,204597,277870,74334,446478,490086) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.009292s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101497 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000511s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101497 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001107s ]