SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407431 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407431 [ RunTime:0.001594s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (457305,459032,201887,1035795,260138,653981,936535,788699,341504,42003,176733,646252,268331,881896,399155,516181,244578,176891,154742,938521,466713,626750,96259,259958,746599,124912,159689,14674,513932,267194,433171,920132,915884,401177,403551,834153,641083,253954,731328,677675,534849,672813,466513,273806,700171,306576,61354,427430,744817,234941,187679,565375,685858,290720,749216,212058,55304,142722,607439,786265) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000977s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407431 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407431 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]