SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451618 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451618 [ RunTime:0.001862s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (919229,968459,162035,874807,796041,598353,915766,308518,7282,699722,229838,716998,498181,711391,418367,442509,312387,3544,3038,958641,356968,863408,67254,851435,201417,534319,526489,577912,413775,78847,1041455,313789,934870,797699,850448,698862,35732,857242,524815,670487,374859,125305,752896,296687,696514,489384,299796,917114,581835,429197,249004,972470,641092,606297,731042,524766,689033,390698,447154,117198) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451618 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000507s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451618 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000420s ]