SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 324709 LIMIT 1 [ RunTime:0.001542s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 324709 [ RunTime:0.001920s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (318492,522977,554881,794298,100377,299860,20135,857128,1038185,681760,473717,40567,691966,432968,820882,678469,826582,115439,412926,95970,435609,780824,92321,201453,102274,449163,267819,320855,640549,743726,446536,597405,279930,634380,200397,461805,324435,71764,138083,932572,183601,49775,180862,250659,303842,462660,309867,277959,695126,854118,232523,400770,878007,149591,566265,512972,555276,633413,1044499,823435) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 324709 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001740s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 324709 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001384s ]