SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 8428 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 8428 [ RunTime:0.001684s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (375401,440230,571000,206906,292683,889642,223513,73787,818053,338962,325334,126990,352202,293950,1040205,945251,740684,811523,215262,178067,579420,854556,315451,511982,504716,119278,837019,898486,593430,437422,314141,642401,758258,705927,129172,378711,927561,94116,163669,701067,1021022,365792,725071,429712,191795,746813,561284,224183,72051,670417,743409,933903,12389,937289,470928,904393,231999,285508,472296,610001) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 8428 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 8428 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000455s ]