SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 72803 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 72803 [ RunTime:0.001528s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (515083,879967,805666,491707,334061,934562,1034645,866164,655088,100055,684490,311776,622600,116176,852086,609968,585081,239504,108439,902849,907727,552509,918102,351604,479757,37475,1030708,248494,711175,232154,406702,117867,561253,923532,943979,997726,147806,996525,588461,441012,227359,285555,925025,252345,142031,168222,858420,558703,114598,494776,874654,875287,545499,748959,282781,450563,523517,618059,740424,170590) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 72803 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 72803 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]