SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001381s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 991911 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 991911 [ RunTime:0.001668s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (585899,672367,120167,449486,869999,684472,788160,262403,156299,624052,388491,1001973,249215,900722,713504,235620,322685,468413,214859,221161,586666,964850,450770,617875,825212,149882,714172,225639,64045,327561,219748,509012,538625,700020,697435,221942,909458,444527,502855,347707,80489,583065,605770,681627,83176,1005392,1017065,495141,1031385,303376,359414,546949,573202,963158,126066,550448,108149,839764,882867,144746) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 991911 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 991911 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]