SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001843s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1044017 LIMIT 1 [ RunTime:0.000517s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044017 [ RunTime:0.002382s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (863664,470464,164218,269268,696906,541316,93957,173729,964625,819903,787553,170254,143082,940111,779879,147742,435647,1002631,278609,371495,924677,826642,915027,806511,128040,587036,816901,632320,475845,602499,336184,992490,391940,773385,1037691,715808,345850,279737,467828,492097,787679,838272,185881,36401,117116,170969,673385,231688,716302,770253,182536,657100,389825,191159,489151,677501,554712,359156,307640,476045) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1044017 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000849s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1044017 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]