SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501439 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501439 [ RunTime:0.001554s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (450147,501354,1031181,1034159,1012820,948937,176961,784888,791854,745024,493929,877972,237756,483921,228003,693203,926616,950924,325537,873655,61258,527542,722895,1031001,741375,698211,271087,291912,613384,673244,531146,375780,73475,706872,266652,330907,743682,586428,206031,25043,199342,366143,64616,1042571,243063,327390,1571,503900,285232,964876,939533,746908,82571,535102,932972,881823,565546,761477,582791,687986) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000954s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501439 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501439 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000440s ]