SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 435223 LIMIT 1 [ RunTime:0.000440s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 435223 [ RunTime:0.001710s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (300582,429657,391681,680081,23445,974065,547499,1038324,767630,557825,210418,634275,352498,164944,205542,870192,920016,308005,273258,1015267,169879,420937,726176,652311,542431,868913,305583,21537,623897,274697,43243,929131,326636,232127,538212,612862,473209,350907,133358,565193,413984,853188,297153,4008,301143,162993,488222,93614,1048774,655407,706327,239018,162599,968895,140759,459469,942374,331590,485690,404179) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001604s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 435223 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 435223 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]