SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310191 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310191 [ RunTime:0.002093s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (984498,969541,650242,332978,158807,840450,24300,933868,874774,174218,828906,236979,498398,348108,896581,709698,221385,951103,920731,899277,909416,217319,340371,535927,32075,655817,60493,1043558,633084,432560,632658,2164,557771,618649,922086,81378,926665,667904,528940,811125,701878,363271,769858,630802,895109,800717,36575,504865,246695,817431,639945,359707,88500,847170,447934,983301,32013,511479,961551,656073) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310191 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310191 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000444s ]