SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 485031 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 485031 [ RunTime:0.001531s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (996271,176167,795711,608539,832705,1009107,321876,23942,922819,984198,599830,643204,176000,178319,448404,239557,226036,412746,816713,1004688,642211,823320,699973,66270,195528,969121,561082,376639,562067,200703,819962,393965,618908,701700,950704,520928,353393,195201,2051,315808,865907,428347,560532,307678,481230,510469,500551,331354,703728,433475,691237,206682,274767,898964,40926,816814,747770,70022,155574,400320) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 485031 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 485031 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000494s ]