SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001552s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499686 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499686 [ RunTime:0.001795s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (663239,928165,159123,375934,589092,419972,11463,361061,214726,417329,819322,674327,141108,512183,869064,997791,590643,526768,1027597,439145,420390,8268,9548,182989,382889,43142,776869,149812,605841,488678,1007567,280816,781218,1007521,682050,352654,183235,568184,945283,758808,217056,419060,373897,153323,262287,901254,28742,586430,547277,655017,110146,944912,1037346,238600,363635,952581,325338,51867,1026912,70744) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499686 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499686 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]