SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 253180 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 253180 [ RunTime:0.001526s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (539701,495446,880642,219165,157615,770758,446690,778658,999647,584814,194282,115237,676808,57226,938917,986595,491171,840717,996540,822172,154536,177692,652214,545813,105203,85997,495,44320,152558,56089,314013,242727,925201,1040562,438708,689450,784130,779886,511656,248045,492374,389332,189639,3296,157594,826616,261238,72372,829450,541267,654078,716268,299338,687561,798985,516094,902957,88195,928963,138142) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 253180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 253180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]