SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 235050 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 235050 [ RunTime:0.001746s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (443883,332819,688853,560455,732189,809910,417866,69202,575211,855033,629198,155181,1047418,996192,686110,107134,740467,787806,90818,773079,1006044,631009,56652,1040242,335384,475851,359333,1042271,353851,1036428,614904,507795,771577,801695,55447,459116,862092,34309,267135,757760,88452,987321,689745,775149,293618,465082,734138,626000,289109,224887,479311,181718,832832,1017318,878509,634325,751833,813024,923099,142478) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 235050 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 235050 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000675s ]