SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 243680 LIMIT 1 [ RunTime:0.001534s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 243680 [ RunTime:0.003413s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (747046,443690,601968,616891,672366,484767,878194,276345,180888,923945,1033051,198999,192087,766163,266300,985258,749697,640887,82573,507694,1020894,29633,768239,924232,900328,107674,441249,431744,22040,111261,215686,978940,199745,657199,748100,856195,495660,828988,520955,499307,378781,25221,138055,490773,810732,547696,257275,355081,239236,379449,903232,856547,112925,689709,472245,126733,1035720,546391,678058,669425) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 243680 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 243680 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]