SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 945075 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 945075 [ RunTime:0.002270s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (484882,544732,993521,281174,731960,137009,275183,364485,448093,146745,247138,460955,31809,892639,735090,77572,756444,665690,784923,161628,365637,934160,247650,164569,515805,826830,652091,925319,597110,310541,926548,216651,75956,493653,737584,428595,893476,474263,951941,301422,323151,314567,231358,965162,514790,886740,455917,722495,96792,578216,306889,140475,305888,624582,791293,304736,162960,34740,543760,341685) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 945075 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 945075 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]